IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_TriviaQuestionIMP')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_TriviaQuestionIMP
  END


CREATE TABLE [dbo].[CGO_TriviaQuestionIMP]
  (
    [ImportID] [int] NOT NULL IDENTITY(1, 1),
    [QuestionID] [int] NULL,
    [Category] [nvarchar] (255) NULL,
    [Question] [nvarchar] (1000) NULL,
    [CorrectAnswer] [nvarchar] (255) NULL,
    [AnswerB] [nvarchar] (255) NULL,
    [AnswerC] [nvarchar] (255) NULL,
    [AnswerD] [nvarchar] (255) NULL,
    [Difficulty] [int] NULL,
    [Comment] [nvarchar] (2000) NULL,
    [Imported] [bit] NULL
  )
ON
  [PRIMARY]
GO
ALTER TABLE [dbo].[CGO_TriviaQuestionIMP] ADD CONSTRAINT [PK_CGO_TriviaImport] PRIMARY KEY CLUSTERED  ([ImportID]) ON [PRIMARY]
GO






